---
title: TimelineState.SetFilterDateRange Method (Excel)
keywords: vbaxl10.chm950079
f1_keywords:
- vbaxl10.chm950079
ms.prod: excel
ms.assetid: c0ceea5c-9aa2-39a2-ce58-e37befeb0175
ms.date: 06/08/2017
---


# TimelineState.SetFilterDateRange Method (Excel)

Sets the Timeline?s filter.


## Syntax

 _expression_ . **SetFilterDateRange**_(StartDate,_ _EndDate)_

 _expression_ A variable that represents a[TimelineState](timelinestate-object-excel.md) object.


### Parameters



|**Name**|**Required/Optional**|**Data type**|**Description**|
|:-----|:-----|:-----|:-----|
| _StartDate_|Required|VARIANT|The start of the filtering date range.|
| _EndDate_|Required|VARIANT|The end of the filtering date range.|

### Return value

 **XLFILTERSTATUS**


## See also


#### Other resources



[TimelineState Object](timelinestate-object-excel.md)

